SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE DeleteAllTables 
	
AS
BEGIN
	SET NOCOUNT ON;

    DELETE FROM Attribute;
    DELETE FROM AttrValue;
    DELETE FROM CityOrRegion;
    DELETE FROM Customer;
    DELETE FROM CustomerAccount;
    DELETE FROM CustomerAddress;
    DELETE FROM CustomerPaymentMethod;
    DELETE FROM Invoice;
    DELETE FROM [Order];
    DELETE FROM OrderItem;
    DELETE FROM Payment;
    DELETE FROM PaymentMethod;
    DELETE FROM Product;
    DELETE FROM ProductAttrValue;
    DELETE FROM ProductComment;
    DELETE FROM ProductPhoto;
    DELETE FROM ProductRating;
    DELETE FROM ProductRatingItem;
    DELETE FROM ProductType;
    DELETE FROM ProductTypeAttrValue;
    DELETE FROM ProductWatchingStatistic;
    DELETE FROM Shipment;
    DELETE FROM ShipmentItem;
    DELETE FROM ShoppingCart;
    DELETE FROM WishList;
    DELETE FROM WishListProduct;
    
END
GO
